package com.giscloud.generator.utils;

import com.giscloud.generator.utils.BusinessException;
import com.giscloud.generator.entity.ColumnEntity;
import com.giscloud.generator.entity.DatabaseEntity;
import com.giscloud.generator.entity.TableEntity;
import org.apache.commons.configuration.Configuration;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.PropertiesConfiguration;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.WordUtils;
import org.apache.velocity.Template;
import org.apache.velocity.VelocityContext;
import org.apache.velocity.app.Velocity;
import org.jasypt.util.text.BasicTextEncryptor;

import java.io.File;
import java.io.IOException;
import java.io.StringWriter;
import java.util.*;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * 代码生成器   工具类
 *
 * @author giscloud
 * @email giscloud@giscloud.top
 * @date 2019-11-19
 */
public class GenUtils {

    public static List<String> getTemplates(){
        List<String> templates = new ArrayList<>();
        templates.add("template/Entity.java.vm");
        templates.add("template/Example.java.vm");
        templates.add("template/Dao.java.vm");
        templates.add("template/DTO.java.vm");
        templates.add("template/Dao.xml.vm");
        templates.add("template/Service.java.vm");
        templates.add("template/ServiceImpl.java.vm");
        templates.add("template/Controller.java.vm");
        templates.add("template/WebMvcConfig.java.vm");
        templates.add("template/Application.java.vm");

        templates.add("template/index.vue.vm");
        templates.add("template/add-or-update.vue.vm");
        templates.add("template/parentpom.xml.vm");
        templates.add("template/pom.xml.vm");
        templates.add("template/banner.txt.vm");
        templates.add("template/log4j2.xml.vm");
        templates.add("template/application.properties.vm");
        templates.add("template/springboot.sh.vm");

        return templates;
    }

    /**
     * 生成代码
     */
    public static void generatorCode(Map<String, String> table,
                                     List<Map<String, String>> columns,
                                     ZipOutputStream zip,
                                     String parentProjectName,
                                     String projectName,
                                     String packageName,
                                     String moduleName,
                                     String checkValues,
                                     DatabaseEntity dbConfig,
                                     Set fileSet) {
        //配置信息
        Configuration config = getConfig();
        boolean hasBigDecimal = false;
        //表信息
        TableEntity tableEntity = new TableEntity();
        tableEntity.setTableName(table.get("tableName" ));
        tableEntity.setComments(table.get("tableComment" ));
        //表名转换成Java类名
        String className = tableToJava(tableEntity.getTableName(), config.getString("tablePrefix" ));
        tableEntity.setClassName(className);
        tableEntity.setClassname(StringUtils.uncapitalize(className));
        //列信息
        List<ColumnEntity> columsList = new ArrayList<>();
        StringBuilder columnNamesSb = new StringBuilder();
        StringBuilder insertValuesSb = new StringBuilder();
        StringBuilder updateSetSb = new StringBuilder();

        String dataType = "";
        for(Map<String, String> column : columns){
            ColumnEntity columnEntity = new ColumnEntity();
            columnEntity.setColumnName(column.get("columnName"));
            dataType = StringUtils.upperCase(column.get("dataType"));
            if("DATETIME".equals(dataType)){
                dataType = "TIMESTAMP";
            }
            if(dbConfig.getDbType().equals("PostgreSQL")){
                dataType = config.getString("pg_"+dataType, dataType );
            }else if(dbConfig.getDbType().equals("MySQL")){
                dataType = config.getString("mysql_"+dataType, dataType );
            }else if(dbConfig.getDbType().equals("Oracle")){
                dataType = config.getString("oracle_"+dataType, dataType );
            }
            columnEntity.setDataType(dataType);
            columnEntity.setComments(column.get("columnComment"));
            columnEntity.setExtra(column.get("extra"));
            //列名转换成Java属性名
            String attrName = columnToJava(columnEntity.getColumnName());
            columnEntity.setAttrName(attrName);
            columnEntity.setAttrname(StringUtils.uncapitalize(attrName));
            //构造dao.xml中需要的内容
            columnNamesSb.append(column.get("columnName")).append(",");
            insertValuesSb.append("#{").append(StringUtils.uncapitalize(attrName))
                    .append(",jdbcType=").append(columnEntity.getDataType())
                    .append("}").append(",");
            updateSetSb.append(column.get("columnName")).append("=").append("#{record.")
                    .append(StringUtils.uncapitalize(attrName))
                    .append(",jdbcType=").append(columnEntity.getDataType())
                    .append("}").append(",");
            //列的数据类型，转换成Java类型
            String attrType = config.getString(column.get("dataType"), "unknowType" );
            columnEntity.setAttrType(attrType);
            if (!hasBigDecimal && attrType.equals("BigDecimal")) {
                hasBigDecimal = true;
            }
            //是否主键
            if ("PRI".equalsIgnoreCase(column.get("columnKey")) && tableEntity.getPk() == null) {
                tableEntity.setPk(columnEntity);
            }

            columsList.add(columnEntity);
        }
        tableEntity.setColumns(columsList);
        //没主键，则第一个字段为主键
        if (tableEntity.getPk() == null) {
            tableEntity.setPk(tableEntity.getColumns().get(0));
        }

        String baseColumnList = "",insertValues = "",updateSet = "";
        if(columnNamesSb != null && columnNamesSb.length() > 0){
            baseColumnList = columnNamesSb.substring(0,columnNamesSb.length()-1);
        }
        if(insertValuesSb != null && insertValuesSb.length() > 0){
            insertValues = insertValuesSb.substring(0,insertValuesSb.length()-1);
        }
        if(updateSetSb != null && updateSetSb.length() > 0){
            updateSet = updateSetSb.substring(0,updateSetSb.length()-1);
        }
        //设置velocity资源加载器
        Properties prop = new Properties();
        prop.put("file.resource.loader.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader" );
        Velocity.init(prop);
        String mainPath = config.getString("mainPath" );
        mainPath = StringUtils.isBlank(mainPath) ? "com.giscloud" : mainPath;
        BasicTextEncryptor textEncryptor = new BasicTextEncryptor();
        String psw = config.getString("jasypt.encryptor.password","giscloudMultiDatasource");
        textEncryptor.setPassword(psw);
        //封装模板数据
        Map<String, Object> map = new HashMap<>();
        map.put("parentProjectName",parentProjectName);
        map.put("projectName",projectName);
        map.put("schema", dbConfig.getDbSchema());
        map.put("dbType", dbConfig.getDbType());
        map.put("encryptor", psw);
        map.put("url", dbConfig.getUrl());
        map.put("user", textEncryptor.encrypt(dbConfig.getUserName()));
        map.put("password", textEncryptor.encrypt(dbConfig.getPassword()));
        map.put("driver", dbConfig.getDriver());
        map.put("tableName", tableEntity.getTableName());
        map.put("comments", tableEntity.getComments());
        map.put("pk", tableEntity.getPk());
        map.put("className", tableEntity.getClassName());
        map.put("classname", tableEntity.getClassname());
        map.put("pathName", tableEntity.getClassname().toLowerCase());
        map.put("columns", tableEntity.getColumns());
        map.put("baseColumnList",baseColumnList);
        map.put("insertValues",insertValues);
        map.put("updateSet",updateSet);
        map.put("hasBigDecimal", hasBigDecimal);
        map.put("mainPath", mainPath);
        map.put("package", packageName);
        map.put("moduleName", moduleName);
        map.put("ModuleName", StringUtils.capitalize(moduleName));
        map.put("author", config.getString("author"));
        map.put("email", config.getString("email"));
        map.put("datetime", DateUtils.format(new Date(), DateUtils.DATE_TIME_PATTERN));
        map.put("component", checkValues);
        VelocityContext context = new VelocityContext(map);

        //获取模板列表
        List<String> templates = getTemplates();
        for (String template : templates) {
            //渲染模板
            StringWriter sw = new StringWriter();
            Template tpl = Velocity.getTemplate(template, "UTF-8" );
            tpl.merge(context, sw);
            try{
                //添加到zip
                String fileName = getFileName(template, tableEntity.getClassName(),projectName, packageName, moduleName,"");
                if(!fileSet.add(fileName)){
                    continue;
                }
                zip.putNextEntry(new ZipEntry(fileName));
                IOUtils.write(sw.toString(), zip, "UTF-8");
                IOUtils.closeQuietly(sw);
                zip.closeEntry();
            } catch (IOException e) {
                throw new BusinessException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
            }
        }
    }


    /**
     * 列名转换成Java属性名
     */
    public static String columnToJava(String columnName) {
        return WordUtils.capitalizeFully(columnName, new char[]{'_'}).replace("_", "" );
    }

    /**
     * 表名转换成Java类名
     */
    public static String tableToJava(String tableName, String tablePrefix) {
        if (StringUtils.isNotBlank(tablePrefix)) {
            tableName = tableName.replaceFirst(tablePrefix, "" );
        }
        return columnToJava(tableName);
    }

    /**
     * 获取配置信息
     */
    public static Configuration getConfig() {
        try {
            return new PropertiesConfiguration("generator.properties" );
        } catch (ConfigurationException e) {
            throw new BusinessException("获取配置文件失败，", e);
        }
    }

    /**
     * 获取文件名
     */
    public static String getFileName(String template, String className, String projectName,String packageName, String moduleName,String checkValues) {
        String packagePath = projectName + File.separator + "src" + File.separator + "main" + File.separator + "java" + File.separator;
        String mainPath =  projectName + File.separator + "src" + File.separator + "main" + File.separator + "java" + File.separator;
        String resourcePath = projectName + File.separator + "src" + File.separator + "main" + File.separator + "resources" + File.separator;
        if (StringUtils.isNotBlank(packageName)) {
            packagePath += packageName.replace(".", File.separator) + File.separator + moduleName + File.separator;
            mainPath += packageName.replace(".", File.separator)+ File.separator;
        }
        if (template.contains("Entity.java.vm" )) {
            return packagePath + "entity" + File.separator + className + ".java";
        }
        if (template.contains("Example.java.vm" )) {
            return packagePath + "entity" + File.separator + className + "Example.java";
        }
        if (template.contains("Application.java.vm" )) {
            return mainPath + StringUtils.capitalize(moduleName) +"Application.java";
        }
        if (template.contains("Dao.java.vm" )) {
            return packagePath + "dao" + File.separator + className + "Dao.java";
        }
        if (template.contains("DTO.java.vm" )) {
            return packagePath + "entity"+ File.separator + "dto" + File.separator + className + "DTO.java";
        }
        if (template.contains("WebMvcConfig.java.vm" )) {
            return packagePath + "core" + File.separator  + "WebMvcConfig.java";
        }
        if (template.contains("Service.java.vm" )) {
            return packagePath + "service" + File.separator + className + "Service.java";
        }
        if (template.contains("ServiceImpl.java.vm" )) {
            return packagePath + "service" + File.separator + "impl" + File.separator + className + "ServiceImpl.java";
        }
        if (template.contains("Controller.java.vm" )) {
            return packagePath + "controller" + File.separator + className + "Controller.java";
        }
        if (template.contains("Dao.xml.vm" )) {
            return resourcePath + "mapper" + File.separator + moduleName + File.separator + className + "Dao.xml";
        }
        if(checkValues.indexOf("front") > 0){
            if (template.contains("index.vue.vm" )) {
                return resourcePath  + "views" + File.separator + "modules" +
                        File.separator + moduleName + File.separator + className.toLowerCase() + ".vue";
            }
            if (template.contains("add-or-update.vue.vm" )) {
                return resourcePath  + "views" + File.separator + "modules" +
                        File.separator + moduleName + File.separator + className.toLowerCase() + "-add-or-update.vue";
            }
        }
        if (template.contains("parentpom.xml.vm" )) {
            return "pom.xml";
        }
        if (template.contains("pom.xml.vm" )) {
            return projectName + File.separator +"pom.xml";
        }

        if (template.contains("log4j2.xml.vm" )) {
            return resourcePath + "log4j2.xml";
        }
        if (template.contains("application.properties.vm" )) {
            return resourcePath + "application.properties";
        }
        if (template.contains("banner.txt.vm" )) {
            return resourcePath + "banner.txt";
        }
        if (template.contains("springboot.sh.vm" )) {
            return resourcePath + "springboot.sh";
        }
        return null;
    }

    public static void generatorCodes(List<DatabaseEntity> databases,
                                      Map<String, String> table,
                                      List<Map<String, String>> columns,
                                      ZipOutputStream zip,
                                      String parentProjectName,
                                      String projectName,
                                      String packageName,
                                      String moduleName,
                                      String checkValues,
                                      DatabaseEntity dbConfig,
                                      Set fileSet,
                                      int ds) {
        //配置信息
        Configuration config = getConfig();
        boolean hasBigDecimal = false;
        //表信息
        TableEntity tableEntity = new TableEntity();
        tableEntity.setTableName(table.get("tableName" ));
        tableEntity.setComments(table.get("tableComment" ));
        //表名转换成Java类名
        String className = tableToJava(tableEntity.getTableName(), config.getString("tablePrefix" ));
        tableEntity.setClassName(className);
        tableEntity.setClassname(StringUtils.uncapitalize(className));
        //列信息
        List<ColumnEntity> columsList = new ArrayList<>();
        StringBuilder columnNamesSb = new StringBuilder();
        StringBuilder insertValuesSb = new StringBuilder();
        StringBuilder updateSetSb = new StringBuilder();

        String dataType = "";
        for(Map<String, String> column : columns){
            ColumnEntity columnEntity = new ColumnEntity();
            columnEntity.setColumnName(column.get("columnName"));
            dataType = StringUtils.upperCase(column.get("dataType"));
            if("DATETIME".equals(dataType)){
                dataType = "TIMESTAMP";
            }
            if(dbConfig.getDbType().equals("PostgreSQL")){
                dataType = config.getString("pg_"+dataType, dataType );
            }else if(dbConfig.getDbType().equals("MySQL")){
                dataType = config.getString("mysql_"+dataType, dataType );
            }else if(dbConfig.getDbType().equals("Oracle")){
                dataType = config.getString("oracle_"+dataType, dataType );
            }
            columnEntity.setDataType(dataType);
            columnEntity.setComments(column.get("columnComment"));
            columnEntity.setExtra(column.get("extra"));
            //列名转换成Java属性名
            String attrName = columnToJava(columnEntity.getColumnName());
            columnEntity.setAttrName(attrName);
            columnEntity.setAttrname(StringUtils.uncapitalize(attrName));
            //构造dao.xml中需要的内容
            columnNamesSb.append(column.get("columnName")).append(",");
            insertValuesSb.append("#{").append(StringUtils.uncapitalize(attrName))
                    .append(",jdbcType=").append(columnEntity.getDataType())
                    .append("}").append(",");
            updateSetSb.append(column.get("columnName")).append("=").append("#{record.")
                    .append(StringUtils.uncapitalize(attrName))
                    .append(",jdbcType=").append(columnEntity.getDataType())
                    .append("}").append(",");
            //列的数据类型，转换成Java类型
            String numLength = column.get("numLength");
            String numBit = column.get("numBit");
            //1）如果不指定number的长度，或指定长度n>18
            //
            //id number not null，转换为pojo类时，为java.math.BigDecimal类型
            //
            //2）如果number的长度在10 <= n <= 18
            //
            //id number(n) not null，转换为pojo类时，为java.lang.Long类型
            //
            //3）如果number的长度在1 <= n <= 9
            //id number(n) not null，转换为pojo类时，为java.lang.Integer类型
            String attrType = config.getString(column.get("dataType"), "unknowType" );
            if("0".equals(numBit)) {
                if (StringUtils.isNotBlank(numLength)) {
                    int numL = Integer.parseInt(numLength);
                    if (numL > 18) {
                        attrType = "BigDecimal";
                    } else if (numL >= 10 && numL <= 18) {
                        attrType = "Long";
                    } else {
                        attrType = "Integer";
                    }
                }
            }
            if("1".equals(numBit)){
                attrType = "BigDecimal";
            }
            columnEntity.setAttrType(attrType);
            if (!hasBigDecimal && attrType.equals("BigDecimal")) {
                hasBigDecimal = true;
            }
            //是否主键
            if ("PRI".equalsIgnoreCase(column.get("columnKey")) && tableEntity.getPk() == null) {
                tableEntity.setPk(columnEntity);
            }

            columsList.add(columnEntity);
        }
        tableEntity.setColumns(columsList);
        //没主键，则第一个字段为主键
        if (tableEntity.getPk() == null) {
            tableEntity.setPk(tableEntity.getColumns().get(0));
        }

        String baseColumnList = "",insertValues = "",updateSet = "";
        if(columnNamesSb != null && columnNamesSb.length() > 0){
            baseColumnList = columnNamesSb.substring(0,columnNamesSb.length()-1);
        }
        if(insertValuesSb != null && insertValuesSb.length() > 0){
            insertValues = insertValuesSb.substring(0,insertValuesSb.length()-1);
        }
        if(updateSetSb != null && updateSetSb.length() > 0){
            updateSet = updateSetSb.substring(0,updateSetSb.length()-1);
        }
        //设置velocity资源加载器
        Properties prop = new Properties();
        prop.put("file.resource.loader.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader" );
        Velocity.init(prop);
        String mainPath = config.getString("mainPath" );
        mainPath = StringUtils.isBlank(mainPath) ? "com.giscloud" : mainPath;
        BasicTextEncryptor textEncryptor = new BasicTextEncryptor();
        String psw = config.getString("jasypt.encryptor.password","giscloudMultiDatasource");
        textEncryptor.setPassword(psw);
        String dbTypeStr = "";
        for (DatabaseEntity databasis : databases) {
            databasis.setEncryptionPassword(textEncryptor.encrypt(databasis.getPassword()));
            databasis.setEncryptionUserName(textEncryptor.encrypt(databasis.getUserName()));
            if(checkValues.indexOf("dts") != -1){
                if (databasis.getDbType().equals("MySQL")) {
                    databasis.setType("com.mysql.cj.jdbc.MysqlXADataSource");
                }else if (databasis.getDbType().equals("Oracle")) {
                    databasis.setType("oracle.jdbc.xa.client.OracleXADataSource");
                }else if (databasis.getDbType().equals("SQLServer")) {
                    databasis.setType("com.microsoft.sqlserver.jdbc.SQLServerXADataSource");
                }else if (databasis.getDbType().equals("PostgreSQL")) {
                    databasis.setType("org.postgresql.xa.PGXADataSource");
                }
            }
            dbTypeStr +=","+databasis.getDbType();
        }
        //封装模板数据
        Map<String, Object> map = new HashMap<>();
        map.put("parentProjectName",parentProjectName);
        map.put("projectName",projectName);
        map.put("schema", dbConfig.getDbSchema());
        map.put("dbTypeStr", dbTypeStr);
        map.put("encryptor", psw);
        map.put("databases",databases);
        map.put("tableName", tableEntity.getTableName());
        map.put("comments", tableEntity.getComments());
        map.put("pk", tableEntity.getPk());
        map.put("className", tableEntity.getClassName());
        map.put("classname", tableEntity.getClassname());
        map.put("pathName", tableEntity.getClassname().toLowerCase());
        map.put("columns", tableEntity.getColumns());
        map.put("baseColumnList",baseColumnList);
        map.put("insertValues",insertValues);
        map.put("updateSet",updateSet);
        map.put("hasBigDecimal", hasBigDecimal);
        map.put("mainPath", mainPath);
        map.put("package", packageName);
        map.put("moduleName", moduleName);
        if(databases.size() > 1){
            map.put("ds","ds"+ds);
        }else{
            map.put("ds","ds1");
        }
        map.put("ModuleName", StringUtils.capitalize(moduleName));
        map.put("author", config.getString("author"));
        map.put("email", config.getString("email"));
        map.put("datetime", DateUtils.format(new Date(), DateUtils.DATE_TIME_PATTERN));
        map.put("component", checkValues);
        VelocityContext context = new VelocityContext(map);

        //获取模板列表
        List<String> templates = getTemplates();
        if(checkValues.indexOf("front") == -1){
            templates.remove("template/add-or-update.vue.vm");
            templates.remove("template/index.vue.vm");
        }
        for (String template : templates) {
            //渲染模板
            StringWriter sw = new StringWriter();
            Template tpl = Velocity.getTemplate(template, "UTF-8" );
            tpl.merge(context, sw);
            try{
                //添加到zip
                String fileName = getFileName(template, tableEntity.getClassName(),projectName, packageName, moduleName,checkValues);
                if(!fileSet.add(fileName)){
                    continue;
                }
                zip.putNextEntry(new ZipEntry(fileName));
                IOUtils.write(sw.toString(), zip, "UTF-8");
                IOUtils.closeQuietly(sw);
                zip.closeEntry();
            } catch (IOException e) {
                throw new BusinessException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
            }
        }
    }

}
